package com.sf.protal.mapper;

import com.sf.protal.pojo.AdminRole;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface SecurityMapper {

	@Select("SELECT\n" +
			"\tadmin.user_id,\n" +
			"\tadmin.username,\n" +
			"\tadmin. PASSWORD,\n" +
			"\tadmin.user_phone,\n" +
			"\tadmin.user_wx,\n" +
			"\tadmin.user_state,\n" +
			"\trole. NAME\n" +
			"FROM\n" +
			"\tums_admin admin\n" +
			"LEFT JOIN ums_role role ON admin.user_id = role.id")
	List<AdminRole> getAdminInfo();

}
